Digitorum Solutions

PHP CRUD OPERATIONS (Part 3)

We created pages for the insertion an displaying of record. In this session, we will be covering updation and deletion of data of data. ...

We developed the base for our operations in the last article. In this session, we will be covering insertion and displaying of data.

Create Add Products page:

To start you first need to put navigation to add button that lead you to add page.

Now create file with name add.php and then design input form to enter data.

Let’s understand this part of code in two section.

<?php
    
    require 'main.php';

    if ( !empty($_POST)) {
        // keep track validation errors
        $Pro_nameError = null;
        $Pro_descriptionError = null;
        $Pro_priceError = null;
        
        // keep track post values
        $Pro_name = $_POST['Pro_name'];
        $Pro_description = $_POST['Pro_description'];
        $Pro_price = $_POST['Pro_price'];
        
        // validate input
        $valid = true;
        if (empty($Pro_name)) {
            $Pro_nameError = 'Please enter Product Name';
            $valid = false;
        }
        
        if (empty($Pro_description)) {
            $Pro_descriptionError = 'Please enter Pro_description';
            $valid = false;
        }
        
        if (empty($Pro_price)) {
            $Pro_priceError = 'Please enter Pro_price';
            $valid = false;
        }
        
        // insert data
        if ($valid) {
            $pdo = Products::connect();
            $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            $sql = "INSERT INTO products (Pro_name,Pro_description,Pro_price) values( ?, ?,?)";
            $q = $pdo->prepare($sql);
            $q->execute(array($Pro_name,$Pro_description,$Pro_price));
            Products::disconnect();
            header("Location: index.php");
        }
    }
?>

In first section you check whether the form is submitted or not by checking $_POST variable. If so, now you have to check each entry to ensure they are not empty.

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <link   href="css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="css/font-awesome.min.css">
    <script src="js/bootstrap.min.js"></script>
    <link href="css/style.css" rel="stylesheet" />
</head>

<body>
    <div class="container">
    
                <div class="span10 offset1">
                    <div class="row text-center">
                        <h3>Add New Product</h3>
                    </div>
             <form class="form-horizontal" action="add.php" method="post">
                  <div class="control-group <?php echo !empty($Pro_nameError)?'error':'';?>">
                        <label class="control-label">NAME</label>
                        <div class="controls">
                            <input name="Pro_name" type="text" placeholder="Name" value="<?php echo            !empty($Pro_name)?$Pro_name:'';?>">
                            <?php if (!empty($Pro_nameError)): ?>
                                <span class="help-inline"><?php echo $Pro_nameError;?></span>
                            <?php endif;?>
                        </div>
                      </div>
                      <div class="control-group <?php echo !empty($Pro_descriptionError)?'error':'';?>">
                        <label class="control-label">Description</label>
                        <div class="controls">
                            <input name="Pro_description" type="text"  placeholder="Description" value="<?php echo !empty($Pro_description)?$Pro_description:'';?>">
                            <?php if (!empty($Pro_descriptionError)): ?>
                                <span class="help-inline"><?php echo $Pro_descriptionError;?></span>
                            <?php endif;?>
                        </div>
                      </div>
                       <div class="control-group <?php echo !empty($Pro_priceError)?'error':'';?>">
                        <label class="control-label">Price</label>
                        <div class="controls">
                            <input name="Pro_price" type="text" placeholder="Price" value="<?php echo !empty($Pro_price)?$Pro_price:'';?>">
                            <?php if (!empty($Pro_priceError)): ?>
                                <span class="help-inline"><?php echo $Pro_priceError;?></span>
                            <?php endif;?>
                        </div>
                      </div>
                      <div class="form-actions">
                          <button type="submit" class="btn"><i class="fa fa-check"></i>Add New</button>
                          <a class="btn" href="index.php"><i class="fa fa-arrow-left"></i>Back</a>
                        </div>
                    </form>
                </div>
                
    </div> <!-- /container -->
  </body>
</html>

Second section is a simple HTML. You just design an input form.

Query for data insert:

1	$sql = "INSERT INTO products (Pro_name,Pro_description,Pro_price) values( ?, ?,?)";

Note: You don’t need to enter “id” as auto increment is enabled and it will be automatically entered. Both the section will be in same file.

Create View page:

Here $_GET['id'] variable is used. That will try to find the “id” if it is not found, it redirects to "index.php" page. Otherwise, it will read data from database using the "id" field and store data into a PHP variable $data.

Query for viewing data:

1	$sql="SELECT * FROM products where Pro_id = ?";

<?php
    require 'main.php';
    $Pro_id = null;
    if ( !empty($_GET['Pro_id'])) {
        $Pro_id = $_REQUEST['Pro_id'];
    }
     
    if ( null==$Pro_id ) {
        header("Location: index.php");
    } else {
        $pdo = Products::connect();
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $sql = "SELECT * FROM products where Pro_id = ?";
        $q = $pdo->prepare($sql);
        $q->execute(array($Pro_id));
        $data = $q->fetch(PDO::FETCH_ASSOC);
        Products::disconnect();
    }
?>
 
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <link   href="css/bootstrap.min.css" rel="stylesheet">
 <link rel="stylesheet" href="css/font-awesome.min.css">
    <script src="js/bootstrap.min.js"></script>
 <link href="css/style.css" rel="stylesheet" />
</head>
 
<body>
    <div class="container">
     
                <div class="span10 offset1">
                    <div class="row">
                        <h3>Products</h3>
                    </div>
                     
                    <table class="table table-striped table-bordered">
                  <thead>
                    <tr>
                      <th>Id</th>
                      <th>Name</th>
                      <th>Description</th>
    <th>Price</th>
    </tr>
                  </thead>
                  <tbody>
               
                            <?php echo '<tr>';?>
                            <?php echo '<td>'. $data['Pro_id'] . '</td>';?>
                            <?php echo '<td>'. $data['Pro_name'] . '</td>';?>
                            <?php echo '<td>'. $data['Pro_description'] . '</td>';?>
          <?php echo '<td>'. $data['Pro_price'] . '</td>';?>
          <?php echo '</tr>';?>
                 </tbody>
       </table>
  <div class="form-actions">
                  <a class="btn" href="index.php"><i class="fa fa-arrow-left"></i>Back</a>
                   </div>
 </div>
   </div> <!-- /container -->
  </body>
</html>

That's all from this session. We have insert and display the record from the database. There will be one more session, which will cover the updation and deletion of data.

PHP CRUD OPERATIONS (Part 2)

We developed the base for our operations in the last article. In this session, we will be covering insertion and displaying of data. C...

When you are working on PHP web development, CRUD is frequently executed. CRUD stands for create, read/view, update, delete.

This is done using several step that are described below:

Step1: Create database

To implement PHP current operations, essentially and primarily you have to install EasyPHP. In EasyPHP tables (Products) are manually created.

Step2: Create file named “main.php”:

After creating table, now you create file with the name "main.php" that mainly takes care of all the stuff related to database connection and disconnection. To use this class (main.php), you need to supply correct values for $dbName, $dbHost, $dbUsername, $dbUserPassword as stated in code below.

<?php
class Products
{
    private static $dbName = 'products' ;
    private static $dbHost = 'localhost' ;
    private static $dbUsername = 'root';
    private static $dbUserPassword = '';
    private static $cont  = null;
    
    public function __construct() {
        die('Init function is not allowed');
    }
    
    public static function connect()
    {
       // One connection through whole application
       if ( null == self::$cont )
       {    
        try
        {
          self::$cont =  new PDO( "mysql:host=".self::$dbHost.";"."dbname=".self::$dbName, self::$dbUsername, self::$dbUserPassword);
        }
        catch(PDOException $e)
        {
          die($e->getMessage());
        }
       }
       return self::$cont;
    }
    
    public static function disconnect()
    {
        self::$cont = null;
    }
}
?>

$dbName: Database name which you use to store 'products' table.
$dbHost: Database host, this is normally "localhost".
$dbUsername: Database username.
$dbUserPassword: Database user's password

This class has three main functions:

construct(): This is the constructor of class ( Constructor allows appropriate initialization of newly created object) .
connect: This is the main function of this class. We use Database::connect() to create a connection.
disconnect: Disconnect from database. It simply sets connection to NULL.

Step3: Create file “index.php”:

In third step you create the grid that will contain the data and present to user

Right now you can only add data manually to tables as we did:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <link   href="css/bootstrap.min.css" rel="stylesheet">
            <link rel="stylesheet" href="css/font-awesome.min.css">
            <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
            <link href="css/style.css" rel="stylesheet" />
    <script src="js/bootstrap.min.js"></script>
</head>

<body>
    <div class="container">
            <div class="row ">
                <h3>PHP Current Tutorial</h3>
            </div>
            <div class="row">
                  
                <table class="table table-striped table-bordered">
                  <thead>
                    <tr>
                      <th>Id</th>
                      <th>Name</th>
                      <th>Description</th>
                     <th>Price</th>
                     <th>Action</th>
                    </tr>
                  </thead>
                  <tbody>
                  <?php
                   include 'main.php';
                   $pdo = Products::connect();
                   $sql = 'SELECT * FROM products Order BY Pro_id';
                   foreach ($pdo->query($sql) as $row) {
                            echo '<tr>';
                            echo '<td>'. $row['Pro_id'] . '</td>';
                            echo '<td>'. $row['Pro_name'] . '</td>';
                            echo '<td>'. $row['Pro_description'] . '</td>';
                          echo '<td>'. $row['Pro_price'] . '</td>';
                          echo '</td>';
                          echo '</tr>';
                   }
                   Products::disconnect();
                  ?>
                  </tbody>
            </table>
        </div>
    </div> <!-- /container -->
  </body>
</html>

Step 4: Add the current operations button.

Now put on a button that add products :

Below is the code of adding button, put it after line 17

1
2
3

<p>
  <a href="add.php" class="btn btn-success"><i class="fa fa-plus-circle"></i> Add                                    Products</a>

</p>

Now add view, update, and delete button:

Add below mentioned code after line 42 to add Action buttons

echo '<td width=300>';
echo '<a class="btn" href="view.php?Pro_id='.$row['Pro_id'].'"><i class="fa fa-eye"></i> View</a>';
echo ' ';
echo '<a class="btn" href="update.php?Pro_id='.$row['Pro_id'].'"><i class="fa fa-pencil-square-o"></i>Update</a>';
echo ' ';
echo '<a class="btn" href="delete.php?Pro_id='.$row['Pro_id'].'"><i class="fa  fa-trash-o"></i>Delete</a>';
echo '</td>';

That's all from this session. We have covered the basics so far. Proper add, delete, update, read pages will be created in the upcoming sessions..

PHP CRUD OPERATIONS (Part 1)

When you are working on PHP web development, CRUD is frequently executed. CRUD stands for create, read/view, update, delete. This is don...

PHP CRUD OPERATIONS (Part 3)

PHP CRUD OPERATIONS (Part 2)

PHP CRUD OPERATIONS (Part 1)

Categories

Popular Posts

Contact Us

About Us

Drop Your Message